{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "100000\n",
      "10\n",
      "10\n",
      "0.0\n"
     ]
    }
   ],
   "source": [
    "import time\n",
    "import networkx as nx\n",
    "from itertools import islice\n",
    "\n",
    "G = nx.barabasi_albert_graph(100000,10)\n",
    "arr = G.nodes\n",
    "print len(arr)\n",
    "\n",
    "print next(islice(arr, 10, 11))\n",
    "print list(arr)[10]\n",
    "\n",
    "# start = time.time()\n",
    "# list(arr)[:1000]\n",
    "# end = time.time()\n",
    "# print end - start\n",
    "\n",
    "\n",
    "# start = time.time()\n",
    "# list(islice(arr,1000))\n",
    "# end = time.time()\n",
    "# print end - start\n",
    "\n",
    "\n",
    "# start = time.time()\n",
    "# arr2 = list(arr)\n",
    "# for i in range(100):\n",
    "#     arr2[i]\n",
    "# end = time.time()\n",
    "# print end - start\n",
    "\n",
    "# start = time.time()\n",
    "# for i in range(100):\n",
    "#     next(islice(arr, i, i+1))\n",
    "# end = time.time()\n",
    "# print end - start\n",
    "\n",
    "# start = time.time()\n",
    "# for i in range(100):\n",
    "#     list(arr)[i]\n",
    "# end = time.time()\n",
    "print end - start"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Graph Feature Extraction\n",
    "\n",
    "This library has several independent modules that can be used for different tasks.\n",
    "In this notebook we are going to present the feature extraction module."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "If you want to use igraph instead of networkx please install it.\n",
      "If you want to use graphlab instead of networkx please install it.\n"
     ]
    }
   ],
   "source": [
    "from anomalous_vertices_detection.feature_controller import FeatureController\n",
    "from anomalous_vertices_detection.datasets.academia import load_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data loading\n",
    "First we will load a grpah, in this scenario we using load_data to load academia.edu graph"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Loading graph...\n",
      "Data loaded.\n"
     ]
    }
   ],
   "source": [
    "labels = {\"neg\": \"Real\", \"pos\": \"Fake\"}\n",
    "\n",
    "my_graph, dataset_config = load_data(labels_map=labels)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Feature Extraction\n",
    "Now we are going to init the FeatureController which is an object that manges all the graph feature extraction proccess."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "features = FeatureController(my_graph)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Our package includes several presets of features.\n",
    "The extract_features fucntion expects to get a dictonary that maps the type of the feture, save name, and the function name that should be excuted.\n",
    "We are going to use fast_link_features which contains fast computaional features based on the works of Fire et al. and Chuk..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{False: {'link': {'adamic_adar_index': 'get_adamic_adar_index',\n",
       "   'common_friends': 'get_common_friends',\n",
       "   'jaccards_coefficient': 'get_jaccards_coefficient',\n",
       "   'knn_weight4': 'get_knn_weight4',\n",
       "   'knn_weight8': 'get_knn_weight8',\n",
       "   'preferential_attachment_score': 'get_preferential_attachment_score',\n",
       "   'sum_of_friends': 'get_sum_of_friends',\n",
       "   'total_friends': 'get_total_friends'}},\n",
       " True: {'link': {'bi_common_friends': 'get_bi_common_friends',\n",
       "   'in_common_friends': 'get_in_common_friends',\n",
       "   'is_opposite_direction_friends': 'is_opposite_direction_friends',\n",
       "   'jaccards_coefficient': 'get_jaccards_coefficient',\n",
       "   'knn_weight1': 'get_knn_weight1',\n",
       "   'knn_weight2': 'get_knn_weight2',\n",
       "   'knn_weight3': 'get_knn_weight3',\n",
       "   'knn_weight4': 'get_knn_weight4',\n",
       "   'knn_weight5': 'get_knn_weight5',\n",
       "   'knn_weight6': 'get_knn_weight6',\n",
       "   'knn_weight7': 'get_knn_weight7',\n",
       "   'knn_weight8': 'get_knn_weight8',\n",
       "   'number_of_transitive_friends': 'get_number_of_transitive_friends',\n",
       "   'out_common_friends': 'get_out_common_friends',\n",
       "   'preferential_attachment_score': 'get_preferential_attachment_score',\n",
       "   'total_friends': 'get_total_friends'},\n",
       "  'vertex_u': {'in_degree_u': 'get_in_degree',\n",
       "   'out_degree_u': 'get_out_degree'},\n",
       "  'vertex_v': {'in_degree_v': 'get_in_degree',\n",
       "   'out_degree_v': 'get_out_degree'}}}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from anomalous_vertices_detection.configs.predefined_features_sets import fast_link_features\n",
    "\n",
    "fast_link_features"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###  Edge Feature extraction\n",
    "extract_features_to_file saves the results in a file in order to allow extracting fetures without a memory bound."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████████████████████████████████████████████████████████████████████████████████████| 1000/1000 [00:00<00:00, 3663.00feature/s]\n"
     ]
    }
   ],
   "source": [
    "edges_output_path = \"../output/\" + dataset_config.name + \"_edges.csv\"\n",
    "\n",
    "features.extract_features_to_file(my_graph.edges[:1000], fast_link_features[my_graph.is_directed], edges_output_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>out_degree_v</th>\n",
       "      <th>out_common_friends</th>\n",
       "      <th>bi_common_friends</th>\n",
       "      <th>preferential_attachment_score</th>\n",
       "      <th>is_opposite_direction_friends</th>\n",
       "      <th>jaccards_coefficient</th>\n",
       "      <th>dst</th>\n",
       "      <th>total_friends</th>\n",
       "      <th>number_of_transitive_friends</th>\n",
       "      <th>in_degree_v</th>\n",
       "      <th>...</th>\n",
       "      <th>in_common_friends</th>\n",
       "      <th>out_degree_u</th>\n",
       "      <th>knn_weight1</th>\n",
       "      <th>knn_weight3</th>\n",
       "      <th>knn_weight2</th>\n",
       "      <th>knn_weight5</th>\n",
       "      <th>knn_weight4</th>\n",
       "      <th>knn_weight7</th>\n",
       "      <th>knn_weight6</th>\n",
       "      <th>knn_weight8</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.845782</td>\n",
       "      <td>1.138675</td>\n",
       "      <td>0.801598</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>1.094491</td>\n",
       "      <td>0.138675</td>\n",
       "      <td>0.066815</td>\n",
       "      <td>0.094491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>112.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.716025</td>\n",
       "      <td>0.845782</td>\n",
       "      <td>0.671841</td>\n",
       "      <td>0.080064</td>\n",
       "      <td>0.801598</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>0.054554</td>\n",
       "      <td>0.066815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.043478</td>\n",
       "      <td>235660</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.854700</td>\n",
       "      <td>0.984457</td>\n",
       "      <td>0.781474</td>\n",
       "      <td>0.160128</td>\n",
       "      <td>0.911231</td>\n",
       "      <td>0.196116</td>\n",
       "      <td>0.117851</td>\n",
       "      <td>0.144338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>162.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>208549</td>\n",
       "      <td>27.0</td>\n",
       "      <td>8</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.318242</td>\n",
       "      <td>0.536078</td>\n",
       "      <td>0.349110</td>\n",
       "      <td>0.025318</td>\n",
       "      <td>0.566947</td>\n",
       "      <td>0.059761</td>\n",
       "      <td>0.030261</td>\n",
       "      <td>0.071429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>114.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>49794</td>\n",
       "      <td>20.0</td>\n",
       "      <td>5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>0.345823</td>\n",
       "      <td>0.563660</td>\n",
       "      <td>0.383735</td>\n",
       "      <td>0.029735</td>\n",
       "      <td>0.601571</td>\n",
       "      <td>0.070186</td>\n",
       "      <td>0.035806</td>\n",
       "      <td>0.084515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>204.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.176471</td>\n",
       "      <td>49792</td>\n",
       "      <td>34.0</td>\n",
       "      <td>9</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.298803</td>\n",
       "      <td>0.516640</td>\n",
       "      <td>0.329159</td>\n",
       "      <td>0.022206</td>\n",
       "      <td>0.546995</td>\n",
       "      <td>0.052414</td>\n",
       "      <td>0.027067</td>\n",
       "      <td>0.063888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>402.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.089552</td>\n",
       "      <td>49793</td>\n",
       "      <td>67.0</td>\n",
       "      <td>15</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0.278806</td>\n",
       "      <td>0.496643</td>\n",
       "      <td>0.281396</td>\n",
       "      <td>0.019004</td>\n",
       "      <td>0.499232</td>\n",
       "      <td>0.044856</td>\n",
       "      <td>0.019418</td>\n",
       "      <td>0.045835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>6.0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>84.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>260371</td>\n",
       "      <td>16.0</td>\n",
       "      <td>5</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.368643</td>\n",
       "      <td>0.586479</td>\n",
       "      <td>0.418327</td>\n",
       "      <td>0.033389</td>\n",
       "      <td>0.636163</td>\n",
       "      <td>0.078811</td>\n",
       "      <td>0.041345</td>\n",
       "      <td>0.097590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>6.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>78.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.357143</td>\n",
       "      <td>260372</td>\n",
       "      <td>14.0</td>\n",
       "      <td>6</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.378346</td>\n",
       "      <td>0.596182</td>\n",
       "      <td>0.427389</td>\n",
       "      <td>0.034943</td>\n",
       "      <td>0.645226</td>\n",
       "      <td>0.082479</td>\n",
       "      <td>0.042796</td>\n",
       "      <td>0.101015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>208546</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1</td>\n",
       "      <td>38.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.493461</td>\n",
       "      <td>0.711298</td>\n",
       "      <td>0.660128</td>\n",
       "      <td>0.053376</td>\n",
       "      <td>0.877964</td>\n",
       "      <td>0.125988</td>\n",
       "      <td>0.080064</td>\n",
       "      <td>0.188982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.472008</td>\n",
       "      <td>1.138675</td>\n",
       "      <td>0.427824</td>\n",
       "      <td>0.046225</td>\n",
       "      <td>1.094491</td>\n",
       "      <td>0.138675</td>\n",
       "      <td>0.031497</td>\n",
       "      <td>0.094491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>48863</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>0.540186</td>\n",
       "      <td>0.739572</td>\n",
       "      <td>0.519386</td>\n",
       "      <td>0.061314</td>\n",
       "      <td>0.718772</td>\n",
       "      <td>0.093659</td>\n",
       "      <td>0.053452</td>\n",
       "      <td>0.081650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>222.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>113.0</td>\n",
       "      <td>0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.516640</td>\n",
       "      <td>0.716025</td>\n",
       "      <td>0.472456</td>\n",
       "      <td>0.052414</td>\n",
       "      <td>0.671841</td>\n",
       "      <td>0.080064</td>\n",
       "      <td>0.035714</td>\n",
       "      <td>0.054554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>235660</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.655315</td>\n",
       "      <td>0.854700</td>\n",
       "      <td>0.582089</td>\n",
       "      <td>0.104828</td>\n",
       "      <td>0.781474</td>\n",
       "      <td>0.160128</td>\n",
       "      <td>0.077152</td>\n",
       "      <td>0.117851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>111.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.638675</td>\n",
       "      <td>1.138675</td>\n",
       "      <td>0.594491</td>\n",
       "      <td>0.069338</td>\n",
       "      <td>1.094491</td>\n",
       "      <td>0.138675</td>\n",
       "      <td>0.047246</td>\n",
       "      <td>0.094491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>235660</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.777350</td>\n",
       "      <td>1.277350</td>\n",
       "      <td>0.704124</td>\n",
       "      <td>0.138675</td>\n",
       "      <td>1.204124</td>\n",
       "      <td>0.277350</td>\n",
       "      <td>0.102062</td>\n",
       "      <td>0.204124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>33108</td>\n",
       "      <td>112.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>0.716025</td>\n",
       "      <td>0.845782</td>\n",
       "      <td>0.671841</td>\n",
       "      <td>0.080064</td>\n",
       "      <td>0.801598</td>\n",
       "      <td>0.098058</td>\n",
       "      <td>0.054554</td>\n",
       "      <td>0.066815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.043478</td>\n",
       "      <td>235660</td>\n",
       "      <td>23.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.854700</td>\n",
       "      <td>0.984457</td>\n",
       "      <td>0.781474</td>\n",
       "      <td>0.160128</td>\n",
       "      <td>0.911231</td>\n",
       "      <td>0.196116</td>\n",
       "      <td>0.117851</td>\n",
       "      <td>0.144338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>378470</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.947214</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.154320</td>\n",
       "      <td>0.223607</td>\n",
       "      <td>1.707107</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.316228</td>\n",
       "      <td>0.707107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>480638</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.763046</td>\n",
       "      <td>0.754127</td>\n",
       "      <td>0.892802</td>\n",
       "      <td>0.107211</td>\n",
       "      <td>0.883883</td>\n",
       "      <td>0.102062</td>\n",
       "      <td>0.131306</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>404112</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.763046</td>\n",
       "      <td>0.754127</td>\n",
       "      <td>0.685695</td>\n",
       "      <td>0.107211</td>\n",
       "      <td>0.676777</td>\n",
       "      <td>0.102062</td>\n",
       "      <td>0.092848</td>\n",
       "      <td>0.088388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>151597</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.474370</td>\n",
       "      <td>0.465452</td>\n",
       "      <td>0.593944</td>\n",
       "      <td>0.053606</td>\n",
       "      <td>0.585025</td>\n",
       "      <td>0.051031</td>\n",
       "      <td>0.075810</td>\n",
       "      <td>0.072169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>31.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>527.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.021277</td>\n",
       "      <td>108046</td>\n",
       "      <td>47.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.435695</td>\n",
       "      <td>0.426777</td>\n",
       "      <td>0.421398</td>\n",
       "      <td>0.046424</td>\n",
       "      <td>0.412479</td>\n",
       "      <td>0.044194</td>\n",
       "      <td>0.043769</td>\n",
       "      <td>0.041667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>31.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.031250</td>\n",
       "      <td>7113</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.501923</td>\n",
       "      <td>0.493004</td>\n",
       "      <td>0.763046</td>\n",
       "      <td>0.058722</td>\n",
       "      <td>0.754127</td>\n",
       "      <td>0.055902</td>\n",
       "      <td>0.107211</td>\n",
       "      <td>0.102062</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>310.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>168993</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.487207</td>\n",
       "      <td>0.478288</td>\n",
       "      <td>0.487207</td>\n",
       "      <td>0.055989</td>\n",
       "      <td>0.478288</td>\n",
       "      <td>0.053300</td>\n",
       "      <td>0.055989</td>\n",
       "      <td>0.053300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>620.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>56386</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.343809</td>\n",
       "      <td>0.334891</td>\n",
       "      <td>0.403913</td>\n",
       "      <td>0.029361</td>\n",
       "      <td>0.394995</td>\n",
       "      <td>0.027951</td>\n",
       "      <td>0.040522</td>\n",
       "      <td>0.038576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>248233</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.685695</td>\n",
       "      <td>0.676777</td>\n",
       "      <td>0.593944</td>\n",
       "      <td>0.092848</td>\n",
       "      <td>0.585025</td>\n",
       "      <td>0.088388</td>\n",
       "      <td>0.075810</td>\n",
       "      <td>0.072169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>168997</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.487207</td>\n",
       "      <td>0.478288</td>\n",
       "      <td>0.892802</td>\n",
       "      <td>0.055989</td>\n",
       "      <td>0.883883</td>\n",
       "      <td>0.053300</td>\n",
       "      <td>0.131306</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>545304</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.563660</td>\n",
       "      <td>0.554741</td>\n",
       "      <td>0.892802</td>\n",
       "      <td>0.070186</td>\n",
       "      <td>0.883883</td>\n",
       "      <td>0.066815</td>\n",
       "      <td>0.131306</td>\n",
       "      <td>0.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>31.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>452185</td>\n",
       "      <td>36.0</td>\n",
       "      <td>0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.763046</td>\n",
       "      <td>0.754127</td>\n",
       "      <td>0.593944</td>\n",
       "      <td>0.107211</td>\n",
       "      <td>0.585025</td>\n",
       "      <td>0.102062</td>\n",
       "      <td>0.075810</td>\n",
       "      <td>0.072169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.015152</td>\n",
       "      <td>18077</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.285278</td>\n",
       "      <td>0.238417</td>\n",
       "      <td>0.876138</td>\n",
       "      <td>0.019649</td>\n",
       "      <td>0.829276</td>\n",
       "      <td>0.014202</td>\n",
       "      <td>0.119523</td>\n",
       "      <td>0.086387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>542230</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>0.876138</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>0.829276</td>\n",
       "      <td>0.122169</td>\n",
       "      <td>0.119523</td>\n",
       "      <td>0.086387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>542231</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>0.122169</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>0.122169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>542232</td>\n",
       "      <td>67.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.746381</td>\n",
       "      <td>0.699520</td>\n",
       "      <td>0.876138</td>\n",
       "      <td>0.097590</td>\n",
       "      <td>0.829276</td>\n",
       "      <td>0.070535</td>\n",
       "      <td>0.119523</td>\n",
       "      <td>0.086387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>542233</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>0.122169</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>0.122169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>66.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>132.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.030303</td>\n",
       "      <td>192231</td>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.522584</td>\n",
       "      <td>0.475723</td>\n",
       "      <td>0.746381</td>\n",
       "      <td>0.059761</td>\n",
       "      <td>0.699520</td>\n",
       "      <td>0.043193</td>\n",
       "      <td>0.097590</td>\n",
       "      <td>0.070535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>66.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>13134.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.007605</td>\n",
       "      <td>113263</td>\n",
       "      <td>263.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>199.0</td>\n",
       "      <td>0.243984</td>\n",
       "      <td>0.197123</td>\n",
       "      <td>0.239742</td>\n",
       "      <td>0.012669</td>\n",
       "      <td>0.192880</td>\n",
       "      <td>0.009157</td>\n",
       "      <td>0.011952</td>\n",
       "      <td>0.008639</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>9966.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.004630</td>\n",
       "      <td>878</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>151.0</td>\n",
       "      <td>0.251230</td>\n",
       "      <td>0.204369</td>\n",
       "      <td>0.250142</td>\n",
       "      <td>0.013894</td>\n",
       "      <td>0.203280</td>\n",
       "      <td>0.010042</td>\n",
       "      <td>0.013710</td>\n",
       "      <td>0.009909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>66.0</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>17160.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.034921</td>\n",
       "      <td>25133</td>\n",
       "      <td>315.0</td>\n",
       "      <td>5</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>260.0</td>\n",
       "      <td>0.236451</td>\n",
       "      <td>0.189589</td>\n",
       "      <td>0.230929</td>\n",
       "      <td>0.011396</td>\n",
       "      <td>0.184068</td>\n",
       "      <td>0.008237</td>\n",
       "      <td>0.010463</td>\n",
       "      <td>0.007562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>66.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>660.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.027027</td>\n",
       "      <td>398550</td>\n",
       "      <td>74.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.457706</td>\n",
       "      <td>0.410845</td>\n",
       "      <td>0.470542</td>\n",
       "      <td>0.048795</td>\n",
       "      <td>0.423681</td>\n",
       "      <td>0.035267</td>\n",
       "      <td>0.050965</td>\n",
       "      <td>0.036835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>330.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>343485</td>\n",
       "      <td>71.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.457706</td>\n",
       "      <td>0.410845</td>\n",
       "      <td>0.577279</td>\n",
       "      <td>0.048795</td>\n",
       "      <td>0.530418</td>\n",
       "      <td>0.035267</td>\n",
       "      <td>0.069007</td>\n",
       "      <td>0.049875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>66.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1386.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.035714</td>\n",
       "      <td>3180</td>\n",
       "      <td>84.0</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.354726</td>\n",
       "      <td>0.307865</td>\n",
       "      <td>0.382232</td>\n",
       "      <td>0.031388</td>\n",
       "      <td>0.335370</td>\n",
       "      <td>0.022686</td>\n",
       "      <td>0.036037</td>\n",
       "      <td>0.026047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>66.0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>2244.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.136364</td>\n",
       "      <td>339576</td>\n",
       "      <td>88.0</td>\n",
       "      <td>4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.343109</td>\n",
       "      <td>0.296247</td>\n",
       "      <td>0.338062</td>\n",
       "      <td>0.029424</td>\n",
       "      <td>0.291200</td>\n",
       "      <td>0.021267</td>\n",
       "      <td>0.028571</td>\n",
       "      <td>0.020650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>66.0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>2244.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.136364</td>\n",
       "      <td>339575</td>\n",
       "      <td>88.0</td>\n",
       "      <td>4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.343109</td>\n",
       "      <td>0.296247</td>\n",
       "      <td>0.338062</td>\n",
       "      <td>0.029424</td>\n",
       "      <td>0.291200</td>\n",
       "      <td>0.021267</td>\n",
       "      <td>0.028571</td>\n",
       "      <td>0.020650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>66.0</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>17886.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.033742</td>\n",
       "      <td>16063</td>\n",
       "      <td>326.0</td>\n",
       "      <td>4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>271.0</td>\n",
       "      <td>0.246413</td>\n",
       "      <td>0.199552</td>\n",
       "      <td>0.229665</td>\n",
       "      <td>0.013080</td>\n",
       "      <td>0.182803</td>\n",
       "      <td>0.009454</td>\n",
       "      <td>0.010249</td>\n",
       "      <td>0.007408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>66.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>792.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.068493</td>\n",
       "      <td>403191</td>\n",
       "      <td>73.0</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.446381</td>\n",
       "      <td>0.399520</td>\n",
       "      <td>0.446381</td>\n",
       "      <td>0.046881</td>\n",
       "      <td>0.399520</td>\n",
       "      <td>0.033884</td>\n",
       "      <td>0.046881</td>\n",
       "      <td>0.033884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>66.0</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>1056.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.123288</td>\n",
       "      <td>403190</td>\n",
       "      <td>73.0</td>\n",
       "      <td>6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.404733</td>\n",
       "      <td>0.357872</td>\n",
       "      <td>0.411566</td>\n",
       "      <td>0.039841</td>\n",
       "      <td>0.364705</td>\n",
       "      <td>0.028796</td>\n",
       "      <td>0.040996</td>\n",
       "      <td>0.029630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>66.0</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>1320.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.102564</td>\n",
       "      <td>315092</td>\n",
       "      <td>78.0</td>\n",
       "      <td>5</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.377545</td>\n",
       "      <td>0.330684</td>\n",
       "      <td>0.387249</td>\n",
       "      <td>0.035245</td>\n",
       "      <td>0.340387</td>\n",
       "      <td>0.025474</td>\n",
       "      <td>0.036886</td>\n",
       "      <td>0.026660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>66.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>4950.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.060150</td>\n",
       "      <td>18041</td>\n",
       "      <td>133.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>75.0</td>\n",
       "      <td>0.264813</td>\n",
       "      <td>0.217952</td>\n",
       "      <td>0.283739</td>\n",
       "      <td>0.016190</td>\n",
       "      <td>0.236877</td>\n",
       "      <td>0.011702</td>\n",
       "      <td>0.019389</td>\n",
       "      <td>0.014014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1518.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.011364</td>\n",
       "      <td>120557</td>\n",
       "      <td>88.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.251230</td>\n",
       "      <td>0.204369</td>\n",
       "      <td>0.373155</td>\n",
       "      <td>0.013894</td>\n",
       "      <td>0.326294</td>\n",
       "      <td>0.010042</td>\n",
       "      <td>0.034503</td>\n",
       "      <td>0.024938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>66.0</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>9966.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.028436</td>\n",
       "      <td>126253</td>\n",
       "      <td>211.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>151.0</td>\n",
       "      <td>0.255418</td>\n",
       "      <td>0.208556</td>\n",
       "      <td>0.250142</td>\n",
       "      <td>0.014602</td>\n",
       "      <td>0.203280</td>\n",
       "      <td>0.010554</td>\n",
       "      <td>0.013710</td>\n",
       "      <td>0.009909</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>66.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>792.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.026316</td>\n",
       "      <td>436515</td>\n",
       "      <td>76.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.457706</td>\n",
       "      <td>0.410845</td>\n",
       "      <td>0.446381</td>\n",
       "      <td>0.048795</td>\n",
       "      <td>0.399520</td>\n",
       "      <td>0.035267</td>\n",
       "      <td>0.046881</td>\n",
       "      <td>0.033884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>264.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.014493</td>\n",
       "      <td>124618</td>\n",
       "      <td>69.0</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.377545</td>\n",
       "      <td>0.330684</td>\n",
       "      <td>0.616244</td>\n",
       "      <td>0.035245</td>\n",
       "      <td>0.569383</td>\n",
       "      <td>0.025474</td>\n",
       "      <td>0.075593</td>\n",
       "      <td>0.054636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>66.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1716.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.033708</td>\n",
       "      <td>124595</td>\n",
       "      <td>89.0</td>\n",
       "      <td>1</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.365147</td>\n",
       "      <td>0.318286</td>\n",
       "      <td>0.361481</td>\n",
       "      <td>0.033150</td>\n",
       "      <td>0.314620</td>\n",
       "      <td>0.023959</td>\n",
       "      <td>0.032530</td>\n",
       "      <td>0.023512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>66.0</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>2706.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.091837</td>\n",
       "      <td>196719</td>\n",
       "      <td>98.0</td>\n",
       "      <td>4</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>41.0</td>\n",
       "      <td>0.319787</td>\n",
       "      <td>0.272925</td>\n",
       "      <td>0.323334</td>\n",
       "      <td>0.025482</td>\n",
       "      <td>0.276473</td>\n",
       "      <td>0.018418</td>\n",
       "      <td>0.026082</td>\n",
       "      <td>0.018851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>66.0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>5742.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.055172</td>\n",
       "      <td>82805</td>\n",
       "      <td>145.0</td>\n",
       "      <td>2</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>87.0</td>\n",
       "      <td>0.282991</td>\n",
       "      <td>0.236130</td>\n",
       "      <td>0.275631</td>\n",
       "      <td>0.019263</td>\n",
       "      <td>0.228770</td>\n",
       "      <td>0.013923</td>\n",
       "      <td>0.018019</td>\n",
       "      <td>0.013023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>180919</td>\n",
       "      <td>68.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.669031</td>\n",
       "      <td>0.622169</td>\n",
       "      <td>0.746381</td>\n",
       "      <td>0.084515</td>\n",
       "      <td>0.699520</td>\n",
       "      <td>0.061085</td>\n",
       "      <td>0.097590</td>\n",
       "      <td>0.070535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>198.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6917</td>\n",
       "      <td>69.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.522584</td>\n",
       "      <td>0.475723</td>\n",
       "      <td>0.669031</td>\n",
       "      <td>0.059761</td>\n",
       "      <td>0.622169</td>\n",
       "      <td>0.043193</td>\n",
       "      <td>0.084515</td>\n",
       "      <td>0.061085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>422302</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.669031</td>\n",
       "      <td>0.622169</td>\n",
       "      <td>1.169031</td>\n",
       "      <td>0.084515</td>\n",
       "      <td>1.122169</td>\n",
       "      <td>0.061085</td>\n",
       "      <td>0.169031</td>\n",
       "      <td>0.122169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>66.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2970.0</td>\n",
       "      <td>False</td>\n",
       "      <td>0.009091</td>\n",
       "      <td>92407</td>\n",
       "      <td>110.0</td>\n",
       "      <td>0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0.340529</td>\n",
       "      <td>0.293668</td>\n",
       "      <td>0.316473</td>\n",
       "      <td>0.028989</td>\n",
       "      <td>0.269611</td>\n",
       "      <td>0.020952</td>\n",
       "      <td>0.024922</td>\n",
       "      <td>0.018013</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 23 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     out_degree_v  out_common_friends  bi_common_friends  \\\n",
       "0             0.0                   0                  0   \n",
       "1             1.0                   0                  0   \n",
       "2             1.0                   1                  0   \n",
       "3             6.0                   6                  6   \n",
       "4             6.0                   5                  5   \n",
       "5             6.0                   6                  5   \n",
       "6             6.0                   6                  4   \n",
       "7             6.0                   4                  4   \n",
       "8             6.0                   5                  5   \n",
       "9             6.0                   1                  1   \n",
       "10            0.0                   0                  0   \n",
       "11            2.0                   0                  0   \n",
       "12            2.0                   0                  0   \n",
       "13            2.0                   1                  0   \n",
       "14            0.0                   0                  0   \n",
       "15            0.0                   0                  0   \n",
       "16            1.0                   0                  0   \n",
       "17            1.0                   1                  0   \n",
       "18            0.0                   0                  0   \n",
       "19           31.0                   0                  0   \n",
       "20           31.0                   0                  0   \n",
       "21           31.0                   0                  0   \n",
       "22           31.0                   1                  0   \n",
       "23           31.0                   1                  0   \n",
       "24           31.0                   0                  0   \n",
       "25           31.0                   0                  0   \n",
       "26           31.0                   0                  0   \n",
       "27           31.0                   0                  0   \n",
       "28           31.0                   0                  0   \n",
       "29           31.0                   0                  0   \n",
       "..            ...                 ...                ...   \n",
       "970          66.0                   1                  0   \n",
       "971          66.0                   0                  0   \n",
       "972          66.0                   0                  0   \n",
       "973          66.0                   0                  0   \n",
       "974          66.0                   0                  0   \n",
       "975          66.0                   2                  1   \n",
       "976          66.0                   2                  0   \n",
       "977          66.0                   1                  0   \n",
       "978          66.0                  11                  5   \n",
       "979          66.0                   2                  2   \n",
       "980          66.0                   0                  0   \n",
       "981          66.0                   3                  1   \n",
       "982          66.0                  12                  4   \n",
       "983          66.0                  12                  4   \n",
       "984          66.0                  11                  4   \n",
       "985          66.0                   5                  1   \n",
       "986          66.0                   9                  6   \n",
       "987          66.0                   8                  5   \n",
       "988          66.0                   8                  2   \n",
       "989          66.0                   1                  0   \n",
       "990          66.0                   6                  2   \n",
       "991          66.0                   2                  2   \n",
       "992          66.0                   1                  1   \n",
       "993          66.0                   3                  1   \n",
       "994          66.0                   9                  4   \n",
       "995          66.0                   8                  2   \n",
       "996          66.0                   0                  0   \n",
       "997          66.0                   0                  0   \n",
       "998          66.0                   0                  0   \n",
       "999          66.0                   1                  0   \n",
       "\n",
       "     preferential_attachment_score  is_opposite_direction_friends  \\\n",
       "0                              0.0                          False   \n",
       "1                            111.0                          False   \n",
       "2                             23.0                          False   \n",
       "3                            162.0                          False   \n",
       "4                            114.0                          False   \n",
       "5                            204.0                          False   \n",
       "6                            402.0                          False   \n",
       "7                             84.0                          False   \n",
       "8                             78.0                          False   \n",
       "9                             18.0                          False   \n",
       "10                             0.0                          False   \n",
       "11                            98.0                          False   \n",
       "12                           222.0                          False   \n",
       "13                            46.0                          False   \n",
       "14                             0.0                          False   \n",
       "15                             0.0                          False   \n",
       "16                           111.0                          False   \n",
       "17                            23.0                          False   \n",
       "18                             0.0                          False   \n",
       "19                            31.0                          False   \n",
       "20                            93.0                          False   \n",
       "21                           155.0                          False   \n",
       "22                           527.0                          False   \n",
       "23                            62.0                          False   \n",
       "24                           310.0                          False   \n",
       "25                           620.0                          False   \n",
       "26                           155.0                          False   \n",
       "27                            31.0                          False   \n",
       "28                            31.0                          False   \n",
       "29                           155.0                          False   \n",
       "..                             ...                            ...   \n",
       "970                           66.0                          False   \n",
       "971                           66.0                          False   \n",
       "972                            0.0                          False   \n",
       "973                           66.0                          False   \n",
       "974                            0.0                          False   \n",
       "975                          132.0                          False   \n",
       "976                        13134.0                          False   \n",
       "977                         9966.0                          False   \n",
       "978                        17160.0                          False   \n",
       "979                          660.0                          False   \n",
       "980                          330.0                          False   \n",
       "981                         1386.0                          False   \n",
       "982                         2244.0                          False   \n",
       "983                         2244.0                          False   \n",
       "984                        17886.0                          False   \n",
       "985                          792.0                          False   \n",
       "986                         1056.0                          False   \n",
       "987                         1320.0                          False   \n",
       "988                         4950.0                          False   \n",
       "989                         1518.0                          False   \n",
       "990                         9966.0                          False   \n",
       "991                          792.0                          False   \n",
       "992                          264.0                          False   \n",
       "993                         1716.0                          False   \n",
       "994                         2706.0                          False   \n",
       "995                         5742.0                          False   \n",
       "996                          132.0                          False   \n",
       "997                          198.0                          False   \n",
       "998                            0.0                          False   \n",
       "999                         2970.0                          False   \n",
       "\n",
       "     jaccards_coefficient     dst  total_friends  \\\n",
       "0                0.000000   33108          111.0   \n",
       "1                0.000000   33108          112.0   \n",
       "2                0.043478  235660           23.0   \n",
       "3                0.222222  208549           27.0   \n",
       "4                0.250000   49794           20.0   \n",
       "5                0.176471   49792           34.0   \n",
       "6                0.089552   49793           67.0   \n",
       "7                0.250000  260371           16.0   \n",
       "8                0.357143  260372           14.0   \n",
       "9                0.125000  208546            8.0   \n",
       "10               0.000000   33108          111.0   \n",
       "11               0.000000   48863           51.0   \n",
       "12               0.000000   33108          113.0   \n",
       "13               0.041667  235660           24.0   \n",
       "14               0.000000   33108          111.0   \n",
       "15               0.000000  235660           23.0   \n",
       "16               0.000000   33108          112.0   \n",
       "17               0.043478  235660           23.0   \n",
       "18               0.000000  378470            1.0   \n",
       "19               0.000000  480638           32.0   \n",
       "20               0.000000  404112           34.0   \n",
       "21               0.000000  151597           36.0   \n",
       "22               0.021277  108046           47.0   \n",
       "23               0.031250    7113           32.0   \n",
       "24               0.000000  168993           41.0   \n",
       "25               0.000000   56386           51.0   \n",
       "26               0.000000  248233           36.0   \n",
       "27               0.000000  168997           32.0   \n",
       "28               0.000000  545304           32.0   \n",
       "29               0.000000  452185           36.0   \n",
       "..                    ...     ...            ...   \n",
       "970              0.015152   18077           66.0   \n",
       "971              0.000000  542230           67.0   \n",
       "972              0.000000  542231           66.0   \n",
       "973              0.000000  542232           67.0   \n",
       "974              0.000000  542233           66.0   \n",
       "975              0.030303  192231           66.0   \n",
       "976              0.007605  113263          263.0   \n",
       "977              0.004630     878          216.0   \n",
       "978              0.034921   25133          315.0   \n",
       "979              0.027027  398550           74.0   \n",
       "980              0.000000  343485           71.0   \n",
       "981              0.035714    3180           84.0   \n",
       "982              0.136364  339576           88.0   \n",
       "983              0.136364  339575           88.0   \n",
       "984              0.033742   16063          326.0   \n",
       "985              0.068493  403191           73.0   \n",
       "986              0.123288  403190           73.0   \n",
       "987              0.102564  315092           78.0   \n",
       "988              0.060150   18041          133.0   \n",
       "989              0.011364  120557           88.0   \n",
       "990              0.028436  126253          211.0   \n",
       "991              0.026316  436515           76.0   \n",
       "992              0.014493  124618           69.0   \n",
       "993              0.033708  124595           89.0   \n",
       "994              0.091837  196719           98.0   \n",
       "995              0.055172   82805          145.0   \n",
       "996              0.000000  180919           68.0   \n",
       "997              0.000000    6917           69.0   \n",
       "998              0.000000  422302           66.0   \n",
       "999              0.009091   92407          110.0   \n",
       "\n",
       "     number_of_transitive_friends  in_degree_v     ...       \\\n",
       "0                               0          1.0     ...        \n",
       "1                               0          2.0     ...        \n",
       "2                               1          2.0     ...        \n",
       "3                               8         38.0     ...        \n",
       "4                               5         38.0     ...        \n",
       "5                               9         38.0     ...        \n",
       "6                              15         38.0     ...        \n",
       "7                               5         38.0     ...        \n",
       "8                               6         38.0     ...        \n",
       "9                               1         38.0     ...        \n",
       "10                              0          8.0     ...        \n",
       "11                              0          6.0     ...        \n",
       "12                              0          6.0     ...        \n",
       "13                              1          6.0     ...        \n",
       "14                              1          3.0     ...        \n",
       "15                              1          3.0     ...        \n",
       "16                              0          2.0     ...        \n",
       "17                              1          2.0     ...        \n",
       "18                              0          4.0     ...        \n",
       "19                              0         28.0     ...        \n",
       "20                              0         28.0     ...        \n",
       "21                              0         28.0     ...        \n",
       "22                              0         28.0     ...        \n",
       "23                              0         28.0     ...        \n",
       "24                              0         28.0     ...        \n",
       "25                              0         28.0     ...        \n",
       "26                              0         28.0     ...        \n",
       "27                              0         28.0     ...        \n",
       "28                              0         28.0     ...        \n",
       "29                              0         28.0     ...        \n",
       "..                            ...          ...     ...        \n",
       "970                             0         34.0     ...        \n",
       "971                             0         34.0     ...        \n",
       "972                             0         34.0     ...        \n",
       "973                             0         34.0     ...        \n",
       "974                             0         34.0     ...        \n",
       "975                             1         34.0     ...        \n",
       "976                             0         34.0     ...        \n",
       "977                             0         34.0     ...        \n",
       "978                             5         34.0     ...        \n",
       "979                             2         34.0     ...        \n",
       "980                             0         34.0     ...        \n",
       "981                             1         34.0     ...        \n",
       "982                             4         34.0     ...        \n",
       "983                             4         34.0     ...        \n",
       "984                             4         34.0     ...        \n",
       "985                             1         34.0     ...        \n",
       "986                             6         34.0     ...        \n",
       "987                             5         34.0     ...        \n",
       "988                             2         34.0     ...        \n",
       "989                             0         34.0     ...        \n",
       "990                             2         34.0     ...        \n",
       "991                             2         34.0     ...        \n",
       "992                             1         34.0     ...        \n",
       "993                             1         34.0     ...        \n",
       "994                             4         34.0     ...        \n",
       "995                             2         34.0     ...        \n",
       "996                             0         34.0     ...        \n",
       "997                             0         34.0     ...        \n",
       "998                             0         34.0     ...        \n",
       "999                             0         34.0     ...        \n",
       "\n",
       "     in_common_friends out_degree_u  knn_weight1  knn_weight3  knn_weight2  \\\n",
       "0                    0        111.0     0.845782     1.138675     0.801598   \n",
       "1                    0        111.0     0.716025     0.845782     0.671841   \n",
       "2                    1         23.0     0.854700     0.984457     0.781474   \n",
       "3                    6         27.0     0.318242     0.536078     0.349110   \n",
       "4                    5         19.0     0.345823     0.563660     0.383735   \n",
       "5                    6         34.0     0.298803     0.516640     0.329159   \n",
       "6                    6         67.0     0.278806     0.496643     0.281396   \n",
       "7                    4         14.0     0.368643     0.586479     0.418327   \n",
       "8                    5         13.0     0.378346     0.596182     0.427389   \n",
       "9                    1          3.0     0.493461     0.711298     0.660128   \n",
       "10                   0        111.0     0.472008     1.138675     0.427824   \n",
       "11                   0         49.0     0.540186     0.739572     0.519386   \n",
       "12                   0        111.0     0.516640     0.716025     0.472456   \n",
       "13                   1         23.0     0.655315     0.854700     0.582089   \n",
       "14                   0        111.0     0.638675     1.138675     0.594491   \n",
       "15                   0         23.0     0.777350     1.277350     0.704124   \n",
       "16                   0        111.0     0.716025     0.845782     0.671841   \n",
       "17                   1         23.0     0.854700     0.984457     0.781474   \n",
       "18                   0          1.0     0.947214     1.500000     1.154320   \n",
       "19                   0          1.0     0.763046     0.754127     0.892802   \n",
       "20                   0          3.0     0.763046     0.754127     0.685695   \n",
       "21                   0          5.0     0.474370     0.465452     0.593944   \n",
       "22                   1         17.0     0.435695     0.426777     0.421398   \n",
       "23                   1          2.0     0.501923     0.493004     0.763046   \n",
       "24                   0         10.0     0.487207     0.478288     0.487207   \n",
       "25                   0         20.0     0.343809     0.334891     0.403913   \n",
       "26                   0          5.0     0.685695     0.676777     0.593944   \n",
       "27                   0          1.0     0.487207     0.478288     0.892802   \n",
       "28                   0          1.0     0.563660     0.554741     0.892802   \n",
       "29                   0          5.0     0.763046     0.754127     0.593944   \n",
       "..                 ...          ...          ...          ...          ...   \n",
       "970                  1          1.0     0.285278     0.238417     0.876138   \n",
       "971                  0          1.0     1.169031     1.122169     0.876138   \n",
       "972                  0          0.0     1.169031     1.122169     1.169031   \n",
       "973                  0          1.0     0.746381     0.699520     0.876138   \n",
       "974                  0          0.0     1.169031     1.122169     1.169031   \n",
       "975                  2          2.0     0.522584     0.475723     0.746381   \n",
       "976                  2        199.0     0.243984     0.197123     0.239742   \n",
       "977                  1        151.0     0.251230     0.204369     0.250142   \n",
       "978                 11        260.0     0.236451     0.189589     0.230929   \n",
       "979                  2         10.0     0.457706     0.410845     0.470542   \n",
       "980                  0          5.0     0.457706     0.410845     0.577279   \n",
       "981                  3         21.0     0.354726     0.307865     0.382232   \n",
       "982                 12         34.0     0.343109     0.296247     0.338062   \n",
       "983                 12         34.0     0.343109     0.296247     0.338062   \n",
       "984                 11        271.0     0.246413     0.199552     0.229665   \n",
       "985                  5         12.0     0.446381     0.399520     0.446381   \n",
       "986                  9         16.0     0.404733     0.357872     0.411566   \n",
       "987                  8         20.0     0.377545     0.330684     0.387249   \n",
       "988                  8         75.0     0.264813     0.217952     0.283739   \n",
       "989                  1         23.0     0.251230     0.204369     0.373155   \n",
       "990                  6        151.0     0.255418     0.208556     0.250142   \n",
       "991                  2         12.0     0.457706     0.410845     0.446381   \n",
       "992                  1          4.0     0.377545     0.330684     0.616244   \n",
       "993                  3         26.0     0.365147     0.318286     0.361481   \n",
       "994                  9         41.0     0.319787     0.272925     0.323334   \n",
       "995                  8         87.0     0.282991     0.236130     0.275631   \n",
       "996                  0          2.0     0.669031     0.622169     0.746381   \n",
       "997                  0          3.0     0.522584     0.475723     0.669031   \n",
       "998                  0          0.0     0.669031     0.622169     1.169031   \n",
       "999                  1         45.0     0.340529     0.293668     0.316473   \n",
       "\n",
       "     knn_weight5  knn_weight4  knn_weight7  knn_weight6  knn_weight8  \n",
       "0       0.098058     1.094491     0.138675     0.066815     0.094491  \n",
       "1       0.080064     0.801598     0.098058     0.054554     0.066815  \n",
       "2       0.160128     0.911231     0.196116     0.117851     0.144338  \n",
       "3       0.025318     0.566947     0.059761     0.030261     0.071429  \n",
       "4       0.029735     0.601571     0.070186     0.035806     0.084515  \n",
       "5       0.022206     0.546995     0.052414     0.027067     0.063888  \n",
       "6       0.019004     0.499232     0.044856     0.019418     0.045835  \n",
       "7       0.033389     0.636163     0.078811     0.041345     0.097590  \n",
       "8       0.034943     0.645226     0.082479     0.042796     0.101015  \n",
       "9       0.053376     0.877964     0.125988     0.080064     0.188982  \n",
       "10      0.046225     1.094491     0.138675     0.031497     0.094491  \n",
       "11      0.061314     0.718772     0.093659     0.053452     0.081650  \n",
       "12      0.052414     0.671841     0.080064     0.035714     0.054554  \n",
       "13      0.104828     0.781474     0.160128     0.077152     0.117851  \n",
       "14      0.069338     1.094491     0.138675     0.047246     0.094491  \n",
       "15      0.138675     1.204124     0.277350     0.102062     0.204124  \n",
       "16      0.080064     0.801598     0.098058     0.054554     0.066815  \n",
       "17      0.160128     0.911231     0.196116     0.117851     0.144338  \n",
       "18      0.223607     1.707107     0.500000     0.316228     0.707107  \n",
       "19      0.107211     0.883883     0.102062     0.131306     0.125000  \n",
       "20      0.107211     0.676777     0.102062     0.092848     0.088388  \n",
       "21      0.053606     0.585025     0.051031     0.075810     0.072169  \n",
       "22      0.046424     0.412479     0.044194     0.043769     0.041667  \n",
       "23      0.058722     0.754127     0.055902     0.107211     0.102062  \n",
       "24      0.055989     0.478288     0.053300     0.055989     0.053300  \n",
       "25      0.029361     0.394995     0.027951     0.040522     0.038576  \n",
       "26      0.092848     0.585025     0.088388     0.075810     0.072169  \n",
       "27      0.055989     0.883883     0.053300     0.131306     0.125000  \n",
       "28      0.070186     0.883883     0.066815     0.131306     0.125000  \n",
       "29      0.107211     0.585025     0.102062     0.075810     0.072169  \n",
       "..           ...          ...          ...          ...          ...  \n",
       "970     0.019649     0.829276     0.014202     0.119523     0.086387  \n",
       "971     0.169031     0.829276     0.122169     0.119523     0.086387  \n",
       "972     0.169031     1.122169     0.122169     0.169031     0.122169  \n",
       "973     0.097590     0.829276     0.070535     0.119523     0.086387  \n",
       "974     0.169031     1.122169     0.122169     0.169031     0.122169  \n",
       "975     0.059761     0.699520     0.043193     0.097590     0.070535  \n",
       "976     0.012669     0.192880     0.009157     0.011952     0.008639  \n",
       "977     0.013894     0.203280     0.010042     0.013710     0.009909  \n",
       "978     0.011396     0.184068     0.008237     0.010463     0.007562  \n",
       "979     0.048795     0.423681     0.035267     0.050965     0.036835  \n",
       "980     0.048795     0.530418     0.035267     0.069007     0.049875  \n",
       "981     0.031388     0.335370     0.022686     0.036037     0.026047  \n",
       "982     0.029424     0.291200     0.021267     0.028571     0.020650  \n",
       "983     0.029424     0.291200     0.021267     0.028571     0.020650  \n",
       "984     0.013080     0.182803     0.009454     0.010249     0.007408  \n",
       "985     0.046881     0.399520     0.033884     0.046881     0.033884  \n",
       "986     0.039841     0.364705     0.028796     0.040996     0.029630  \n",
       "987     0.035245     0.340387     0.025474     0.036886     0.026660  \n",
       "988     0.016190     0.236877     0.011702     0.019389     0.014014  \n",
       "989     0.013894     0.326294     0.010042     0.034503     0.024938  \n",
       "990     0.014602     0.203280     0.010554     0.013710     0.009909  \n",
       "991     0.048795     0.399520     0.035267     0.046881     0.033884  \n",
       "992     0.035245     0.569383     0.025474     0.075593     0.054636  \n",
       "993     0.033150     0.314620     0.023959     0.032530     0.023512  \n",
       "994     0.025482     0.276473     0.018418     0.026082     0.018851  \n",
       "995     0.019263     0.228770     0.013923     0.018019     0.013023  \n",
       "996     0.084515     0.699520     0.061085     0.097590     0.070535  \n",
       "997     0.059761     0.622169     0.043193     0.084515     0.061085  \n",
       "998     0.084515     1.122169     0.061085     0.169031     0.122169  \n",
       "999     0.028989     0.269611     0.020952     0.024922     0.018013  \n",
       "\n",
       "[1000 rows x 23 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "edges_df = pd.read_csv(edges_output_path)\n",
    "edges_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "###  Vertices Feature Extraction\n",
    "In the vertices example we are demonstrate the use of features_generator instead of extract_features_to_file which returns a generator."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{True: {'vertex_v': {'average_scc': 'get_average_scc',\n",
       "   'average_scc_plus': 'get_average_scc_plus',\n",
       "   'average_wcc': 'get_average_wcc',\n",
       "   'bi_degree': 'get_bi_degree',\n",
       "   'bi_degree_density': 'get_bi_degree_density',\n",
       "   'density_neighborhood_subgraph': 'get_density_neighborhood_subgraph',\n",
       "   'density_neighborhood_subgraph_plus': 'get_density_neighborhood_subgraph_plus',\n",
       "   'in_degree': 'get_in_degree',\n",
       "   'in_degree_density': 'get_in_degree_density',\n",
       "   'label': 'get_label',\n",
       "   'out_degree': 'get_out_degree',\n",
       "   'out_degree_density': 'get_out_degree_density',\n",
       "   'src': 'get_vertex',\n",
       "   'subgraph_node_link_number': 'get_subgraph_node_link_number',\n",
       "   'subgraph_node_link_number_plus': 'get_subgraph_node_link_number_plus'}}}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from anomalous_vertices_detection.configs.predefined_features_sets import fast_vertex_features\n",
    "fast_vertex_features"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "vertices_fetures = list(features.features_generator(fast_vertex_features[my_graph.is_directed], my_graph.vertices[:1000]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>average_scc</th>\n",
       "      <th>average_scc_plus</th>\n",
       "      <th>average_wcc</th>\n",
       "      <th>bi_degree</th>\n",
       "      <th>bi_degree_density</th>\n",
       "      <th>density_neighborhood_subgraph</th>\n",
       "      <th>density_neighborhood_subgraph_plus</th>\n",
       "      <th>in_degree</th>\n",
       "      <th>in_degree_density</th>\n",
       "      <th>label</th>\n",
       "      <th>out_degree</th>\n",
       "      <th>out_degree_density</th>\n",
       "      <th>src</th>\n",
       "      <th>subgraph_node_link_number</th>\n",
       "      <th>subgraph_node_link_number_plus</th>\n",
       "      <th>vertex_label</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>287144</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>287145</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>287146</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>45.000000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>45.000000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.155556</td>\n",
       "      <td>1.363636</td>\n",
       "      <td>0.957447</td>\n",
       "      <td>38.0</td>\n",
       "      <td>0.844444</td>\n",
       "      <td>Real</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.155556</td>\n",
       "      <td>287147</td>\n",
       "      <td>33</td>\n",
       "      <td>47</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>9.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.888889</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>287140</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>1.285714</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>287141</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>287142</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>287143</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>287148</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>287149</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>378468</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>378469</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2.142857</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>2.307692</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.416667</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.895522</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>Real</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.533333</td>\n",
       "      <td>89370</td>\n",
       "      <td>10</td>\n",
       "      <td>67</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3.800000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>4.222222</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.447368</td>\n",
       "      <td>1.310345</td>\n",
       "      <td>0.593750</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.526316</td>\n",
       "      <td>Real</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.473684</td>\n",
       "      <td>89371</td>\n",
       "      <td>29</td>\n",
       "      <td>64</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1.800000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>1.800000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>Real</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>89372</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2.333333</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>Real</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>89373</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3.333333</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.666667</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.700000</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>89374</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>89375</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3.500000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.285714</td>\n",
       "      <td>89376</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2.166667</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.461538</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>0.812500</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.461538</td>\n",
       "      <td>Real</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.538462</td>\n",
       "      <td>89377</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>9.785714</td>\n",
       "      <td>34.250000</td>\n",
       "      <td>19.571429</td>\n",
       "      <td>60.0</td>\n",
       "      <td>0.437956</td>\n",
       "      <td>0.545817</td>\n",
       "      <td>0.365333</td>\n",
       "      <td>73.0</td>\n",
       "      <td>0.532847</td>\n",
       "      <td>Real</td>\n",
       "      <td>64.0</td>\n",
       "      <td>0.467153</td>\n",
       "      <td>89378</td>\n",
       "      <td>251</td>\n",
       "      <td>375</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4.800000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>4.800000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.291667</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>1.043478</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>Real</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>89379</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5.500000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>13.750000</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.327273</td>\n",
       "      <td>0.423077</td>\n",
       "      <td>0.302198</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.381818</td>\n",
       "      <td>Real</td>\n",
       "      <td>34.0</td>\n",
       "      <td>0.618182</td>\n",
       "      <td>378463</td>\n",
       "      <td>130</td>\n",
       "      <td>182</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5.500000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.181818</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>1.571429</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.727273</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>378460</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>378461</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1.500000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.857143</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>Real</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>117703</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>391271</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>494928</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>494929</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>494920</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>2.500000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.250000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>511825</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>2.333333</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>0.875000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>511824</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>511827</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>511826</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>2.333333</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>2.333333</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.166667</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.571429</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.428571</td>\n",
       "      <td>511821</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>2.800000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>2.800000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>0.777778</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>511820</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>511823</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>511822</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>4.500000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.642857</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.555556</td>\n",
       "      <td>Real</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.444444</td>\n",
       "      <td>561224</td>\n",
       "      <td>6</td>\n",
       "      <td>14</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>561225</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>561226</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.666667</td>\n",
       "      <td>561227</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>561220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>5.538462</td>\n",
       "      <td>7.200000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>0.296296</td>\n",
       "      <td>0.244898</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.513889</td>\n",
       "      <td>Real</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.486111</td>\n",
       "      <td>270352</td>\n",
       "      <td>243</td>\n",
       "      <td>294</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>561222</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>3.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>561223</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>2.875000</td>\n",
       "      <td>3.285714</td>\n",
       "      <td>11.500000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.260870</td>\n",
       "      <td>0.589744</td>\n",
       "      <td>0.383333</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.347826</td>\n",
       "      <td>Real</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.652174</td>\n",
       "      <td>225763</td>\n",
       "      <td>39</td>\n",
       "      <td>60</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>561228</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>561229</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>5.127660</td>\n",
       "      <td>8.033333</td>\n",
       "      <td>13.388889</td>\n",
       "      <td>138.0</td>\n",
       "      <td>0.286307</td>\n",
       "      <td>0.331956</td>\n",
       "      <td>0.261247</td>\n",
       "      <td>227.0</td>\n",
       "      <td>0.470954</td>\n",
       "      <td>Real</td>\n",
       "      <td>255.0</td>\n",
       "      <td>0.529046</td>\n",
       "      <td>31764</td>\n",
       "      <td>1452</td>\n",
       "      <td>1845</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>14.000000</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>42.000000</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.512195</td>\n",
       "      <td>0.338710</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>Real</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.523810</td>\n",
       "      <td>31765</td>\n",
       "      <td>82</td>\n",
       "      <td>124</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>4.461538</td>\n",
       "      <td>19.333333</td>\n",
       "      <td>5.272727</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0.448276</td>\n",
       "      <td>0.906250</td>\n",
       "      <td>0.491525</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.517241</td>\n",
       "      <td>Real</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.482759</td>\n",
       "      <td>31766</td>\n",
       "      <td>64</td>\n",
       "      <td>118</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>6.619048</td>\n",
       "      <td>46.333333</td>\n",
       "      <td>9.266667</td>\n",
       "      <td>37.0</td>\n",
       "      <td>0.266187</td>\n",
       "      <td>2.206349</td>\n",
       "      <td>0.992857</td>\n",
       "      <td>99.0</td>\n",
       "      <td>0.712230</td>\n",
       "      <td>Real</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0.287770</td>\n",
       "      <td>31767</td>\n",
       "      <td>63</td>\n",
       "      <td>140</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>3.829545</td>\n",
       "      <td>5.616667</td>\n",
       "      <td>9.361111</td>\n",
       "      <td>115.0</td>\n",
       "      <td>0.341246</td>\n",
       "      <td>0.401190</td>\n",
       "      <td>0.287788</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.359050</td>\n",
       "      <td>Real</td>\n",
       "      <td>216.0</td>\n",
       "      <td>0.640950</td>\n",
       "      <td>31760</td>\n",
       "      <td>840</td>\n",
       "      <td>1171</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>15.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.033333</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>28.0</td>\n",
       "      <td>0.933333</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.066667</td>\n",
       "      <td>31761</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>5.394737</td>\n",
       "      <td>6.833333</td>\n",
       "      <td>20.500000</td>\n",
       "      <td>66.0</td>\n",
       "      <td>0.321951</td>\n",
       "      <td>0.403543</td>\n",
       "      <td>0.295815</td>\n",
       "      <td>86.0</td>\n",
       "      <td>0.419512</td>\n",
       "      <td>Real</td>\n",
       "      <td>119.0</td>\n",
       "      <td>0.580488</td>\n",
       "      <td>31762</td>\n",
       "      <td>508</td>\n",
       "      <td>693</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>4.285714</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.766667</td>\n",
       "      <td>Real</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.233333</td>\n",
       "      <td>31763</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>Real</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>550930</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>475003</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>Real</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>550932</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Real</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     average_scc  average_scc_plus  average_wcc  bi_degree  bi_degree_density  \\\n",
       "0       0.000000          2.000000     0.000000        0.0           0.000000   \n",
       "1       2.000000          2.000000     2.000000        1.0           0.500000   \n",
       "2       2.000000          4.000000     4.000000        2.0           0.500000   \n",
       "3      45.000000         45.000000    45.000000        7.0           0.155556   \n",
       "4       9.000000          9.000000     9.000000        1.0           0.111111   \n",
       "5       3.000000          9.000000     4.500000        3.0           0.333333   \n",
       "6       0.000000          1.000000     0.000000        0.0           0.000000   \n",
       "7       4.000000          4.000000     4.000000        1.0           0.250000   \n",
       "8       4.000000          4.000000     4.000000        1.0           0.250000   \n",
       "9       2.000000          4.000000     4.000000        2.0           0.500000   \n",
       "10      0.000000          3.000000     0.000000        0.0           0.000000   \n",
       "11      5.000000          5.000000     5.000000        1.0           0.200000   \n",
       "12      2.142857         10.000000     2.307692       25.0           0.416667   \n",
       "13      3.800000         19.000000     4.222222       17.0           0.447368   \n",
       "14      1.800000          4.500000     1.800000        4.0           0.444444   \n",
       "15      2.333333          3.500000     3.500000        3.0           0.428571   \n",
       "16      3.333333         10.000000     3.333333        3.0           0.300000   \n",
       "17      3.000000          6.000000     3.000000        3.0           0.500000   \n",
       "18      3.500000          7.000000     3.500000        2.0           0.285714   \n",
       "19      2.166667          6.500000     2.600000        6.0           0.461538   \n",
       "20      9.785714         34.250000    19.571429       60.0           0.437956   \n",
       "21      4.800000         12.000000     4.800000        7.0           0.291667   \n",
       "22      5.500000          5.500000    13.750000       18.0           0.327273   \n",
       "23      5.500000         11.000000     5.500000        2.0           0.181818   \n",
       "24      0.000000          1.000000     0.000000        0.0           0.000000   \n",
       "25      1.500000          2.000000     2.000000        2.0           0.333333   \n",
       "26      1.000000          0.500000     1.000000        0.0           0.000000   \n",
       "27      0.000000          6.000000     0.000000        0.0           0.000000   \n",
       "28      0.000000          6.000000     0.000000        0.0           0.000000   \n",
       "29      0.000000          3.000000     0.000000        0.0           0.000000   \n",
       "..           ...               ...          ...        ...                ...   \n",
       "970     2.500000          5.000000     2.500000        2.0           0.400000   \n",
       "971     2.333333          7.000000     7.000000        3.0           0.428571   \n",
       "972     0.000000          9.000000     0.000000        0.0           0.000000   \n",
       "973     2.000000          2.000000     2.000000        1.0           0.500000   \n",
       "974     2.333333          7.000000     2.333333        3.0           0.428571   \n",
       "975     2.800000         14.000000     2.800000        7.0           0.500000   \n",
       "976     2.000000          2.000000     2.000000        1.0           0.500000   \n",
       "977     2.000000          6.000000     2.000000        3.0           0.500000   \n",
       "978     4.500000          9.000000     4.500000        4.0           0.444444   \n",
       "979     0.000000          1.000000     0.000000        0.0           0.000000   \n",
       "980     5.000000          5.000000     5.000000        1.0           0.200000   \n",
       "981     1.500000          1.000000     1.500000        0.0           0.000000   \n",
       "982     0.000000          2.000000     0.000000        0.0           0.000000   \n",
       "983     5.538462          7.200000    18.000000       16.0           0.222222   \n",
       "984     0.000000          5.000000     0.000000        0.0           0.000000   \n",
       "985     3.000000          6.000000     3.000000        3.0           0.500000   \n",
       "986     2.875000          3.285714    11.500000        6.0           0.260870   \n",
       "987     0.000000          1.000000     0.000000        0.0           0.000000   \n",
       "988     1.000000          0.500000     1.000000        0.0           0.000000   \n",
       "989     5.127660          8.033333    13.388889      138.0           0.286307   \n",
       "990    14.000000         21.000000    42.000000       20.0           0.476190   \n",
       "991     4.461538         19.333333     5.272727       26.0           0.448276   \n",
       "992     6.619048         46.333333     9.266667       37.0           0.266187   \n",
       "993     3.829545          5.616667     9.361111      115.0           0.341246   \n",
       "994    15.000000         15.000000    15.000000        1.0           0.033333   \n",
       "995     5.394737          6.833333    20.500000       66.0           0.321951   \n",
       "996     4.285714         15.000000     6.000000        6.0           0.200000   \n",
       "997     2.000000          4.000000     2.000000        2.0           0.500000   \n",
       "998     0.000000          5.000000     0.000000        0.0           0.000000   \n",
       "999     1.000000          0.500000     1.000000        0.0           0.000000   \n",
       "\n",
       "     density_neighborhood_subgraph  density_neighborhood_subgraph_plus  \\\n",
       "0                         0.000000                            0.000000   \n",
       "1                         0.000000                            1.000000   \n",
       "2                         4.000000                            0.800000   \n",
       "3                         1.363636                            0.957447   \n",
       "4                         0.000000                            4.500000   \n",
       "5                         9.000000                            1.285714   \n",
       "6                         0.000000                            0.000000   \n",
       "7                         0.000000                            2.000000   \n",
       "8                         0.000000                            2.000000   \n",
       "9                         4.000000                            0.800000   \n",
       "10                        0.000000                            0.000000   \n",
       "11                        0.000000                            2.500000   \n",
       "12                        6.000000                            0.895522   \n",
       "13                        1.310345                            0.593750   \n",
       "14                        0.000000                            1.000000   \n",
       "15                        2.333333                            0.700000   \n",
       "16                        0.000000                            1.666667   \n",
       "17                        3.000000                            0.750000   \n",
       "18                        0.000000                            1.750000   \n",
       "19                        4.333333                            0.812500   \n",
       "20                        0.545817                            0.365333   \n",
       "21                        3.000000                            1.043478   \n",
       "22                        0.423077                            0.302198   \n",
       "23                        5.500000                            1.571429   \n",
       "24                        0.000000                            0.000000   \n",
       "25                        6.000000                            0.857143   \n",
       "26                        0.000000                            1.000000   \n",
       "27                        0.000000                            0.000000   \n",
       "28                        0.000000                            0.000000   \n",
       "29                        0.000000                            0.000000   \n",
       "..                             ...                                 ...   \n",
       "970                       0.000000                            1.250000   \n",
       "971                       3.500000                            0.875000   \n",
       "972                       0.000000                            0.000000   \n",
       "973                       0.000000                            1.000000   \n",
       "974                       0.000000                            1.166667   \n",
       "975                       3.500000                            0.777778   \n",
       "976                       0.000000                            1.000000   \n",
       "977                       0.000000                            1.000000   \n",
       "978                       1.500000                            0.642857   \n",
       "979                       0.000000                            0.000000   \n",
       "980                       0.000000                            2.500000   \n",
       "981                       0.000000                            1.500000   \n",
       "982                       0.000000                            0.000000   \n",
       "983                       0.296296                            0.244898   \n",
       "984                       0.000000                            0.000000   \n",
       "985                       3.000000                            0.750000   \n",
       "986                       0.589744                            0.383333   \n",
       "987                       0.000000                            0.000000   \n",
       "988                       0.000000                            1.000000   \n",
       "989                       0.331956                            0.261247   \n",
       "990                       0.512195                            0.338710   \n",
       "991                       0.906250                            0.491525   \n",
       "992                       2.206349                            0.992857   \n",
       "993                       0.401190                            0.287788   \n",
       "994                       0.000000                           10.000000   \n",
       "995                       0.403543                            0.295815   \n",
       "996                      15.000000                            2.000000   \n",
       "997                       0.000000                            1.000000   \n",
       "998                       0.000000                            0.000000   \n",
       "999                       0.000000                            1.000000   \n",
       "\n",
       "     in_degree  in_degree_density label  out_degree  out_degree_density  \\\n",
       "0          2.0           1.000000  Real         0.0            0.000000   \n",
       "1          1.0           0.500000  Real         1.0            0.500000   \n",
       "2          2.0           0.500000  Real         2.0            0.500000   \n",
       "3         38.0           0.844444  Real         7.0            0.155556   \n",
       "4          8.0           0.888889  Real         1.0            0.111111   \n",
       "5          6.0           0.666667  Real         3.0            0.333333   \n",
       "6          1.0           1.000000  Real         0.0            0.000000   \n",
       "7          3.0           0.750000  Real         1.0            0.250000   \n",
       "8          3.0           0.750000  Real         1.0            0.250000   \n",
       "9          2.0           0.500000  Real         2.0            0.500000   \n",
       "10         3.0           1.000000  Real         0.0            0.000000   \n",
       "11         4.0           0.800000  Real         1.0            0.200000   \n",
       "12        28.0           0.466667  Real        32.0            0.533333   \n",
       "13        20.0           0.526316  Real        18.0            0.473684   \n",
       "14         4.0           0.444444  Real         5.0            0.555556   \n",
       "15         3.0           0.428571  Real         4.0            0.571429   \n",
       "16         7.0           0.700000  Real         3.0            0.300000   \n",
       "17         3.0           0.500000  Real         3.0            0.500000   \n",
       "18         5.0           0.714286  Real         2.0            0.285714   \n",
       "19         6.0           0.461538  Real         7.0            0.538462   \n",
       "20        73.0           0.532847  Real        64.0            0.467153   \n",
       "21        16.0           0.666667  Real         8.0            0.333333   \n",
       "22        21.0           0.381818  Real        34.0            0.618182   \n",
       "23         8.0           0.727273  Real         3.0            0.272727   \n",
       "24         1.0           1.000000  Real         0.0            0.000000   \n",
       "25         2.0           0.333333  Real         4.0            0.666667   \n",
       "26         0.0           0.000000  Real         1.0            1.000000   \n",
       "27         6.0           1.000000  Real         0.0            0.000000   \n",
       "28         6.0           1.000000  Real         0.0            0.000000   \n",
       "29         3.0           1.000000  Real         0.0            0.000000   \n",
       "..         ...                ...   ...         ...                 ...   \n",
       "970        3.0           0.600000  Real         2.0            0.400000   \n",
       "971        4.0           0.571429  Real         3.0            0.428571   \n",
       "972        9.0           1.000000  Real         0.0            0.000000   \n",
       "973        1.0           0.500000  Real         1.0            0.500000   \n",
       "974        4.0           0.571429  Real         3.0            0.428571   \n",
       "975        7.0           0.500000  Real         7.0            0.500000   \n",
       "976        1.0           0.500000  Real         1.0            0.500000   \n",
       "977        3.0           0.500000  Real         3.0            0.500000   \n",
       "978        5.0           0.555556  Real         4.0            0.444444   \n",
       "979        1.0           1.000000  Real         0.0            0.000000   \n",
       "980        4.0           0.800000  Real         1.0            0.200000   \n",
       "981        1.0           0.333333  Real         2.0            0.666667   \n",
       "982        2.0           1.000000  Real         0.0            0.000000   \n",
       "983       37.0           0.513889  Real        35.0            0.486111   \n",
       "984        5.0           1.000000  Real         0.0            0.000000   \n",
       "985        3.0           0.500000  Real         3.0            0.500000   \n",
       "986        8.0           0.347826  Real        15.0            0.652174   \n",
       "987        1.0           1.000000  Real         0.0            0.000000   \n",
       "988        0.0           0.000000  Real         1.0            1.000000   \n",
       "989      227.0           0.470954  Real       255.0            0.529046   \n",
       "990       20.0           0.476190  Real        22.0            0.523810   \n",
       "991       30.0           0.517241  Real        28.0            0.482759   \n",
       "992       99.0           0.712230  Real        40.0            0.287770   \n",
       "993      121.0           0.359050  Real       216.0            0.640950   \n",
       "994       28.0           0.933333  Real         2.0            0.066667   \n",
       "995       86.0           0.419512  Real       119.0            0.580488   \n",
       "996       23.0           0.766667  Real         7.0            0.233333   \n",
       "997        2.0           0.500000  Real         2.0            0.500000   \n",
       "998        5.0           1.000000  Real         0.0            0.000000   \n",
       "999        0.0           0.000000  Real         1.0            1.000000   \n",
       "\n",
       "        src  subgraph_node_link_number  subgraph_node_link_number_plus  \\\n",
       "0    287144                          0                               0   \n",
       "1    287145                          0                               2   \n",
       "2    287146                          1                               5   \n",
       "3    287147                         33                              47   \n",
       "4    287140                          0                               2   \n",
       "5    287141                          1                               7   \n",
       "6    287142                          0                               0   \n",
       "7    287143                          0                               2   \n",
       "8    287148                          0                               2   \n",
       "9    287149                          1                               5   \n",
       "10   378468                          0                               0   \n",
       "11   378469                          0                               2   \n",
       "12    89370                         10                              67   \n",
       "13    89371                         29                              64   \n",
       "14    89372                          0                               9   \n",
       "15    89373                          3                              10   \n",
       "16    89374                          0                               6   \n",
       "17    89375                          2                               8   \n",
       "18    89376                          0                               4   \n",
       "19    89377                          3                              16   \n",
       "20    89378                        251                             375   \n",
       "21    89379                          8                              23   \n",
       "22   378463                        130                             182   \n",
       "23   378460                          2                               7   \n",
       "24   378461                          0                               0   \n",
       "25   117703                          1                               7   \n",
       "26   391271                          0                               1   \n",
       "27   494928                          0                               0   \n",
       "28   494929                          0                               0   \n",
       "29   494920                          0                               0   \n",
       "..      ...                        ...                             ...   \n",
       "970  511825                          0                               4   \n",
       "971  511824                          2                               8   \n",
       "972  511827                          0                               0   \n",
       "973  511826                          0                               2   \n",
       "974  511821                          0                               6   \n",
       "975  511820                          4                              18   \n",
       "976  511823                          0                               2   \n",
       "977  511822                          0                               6   \n",
       "978  561224                          6                              14   \n",
       "979  561225                          0                               0   \n",
       "980  561226                          0                               2   \n",
       "981  561227                          0                               2   \n",
       "982  561220                          0                               0   \n",
       "983  270352                        243                             294   \n",
       "984  561222                          0                               0   \n",
       "985  561223                          2                               8   \n",
       "986  225763                         39                              60   \n",
       "987  561228                          0                               0   \n",
       "988  561229                          0                               1   \n",
       "989   31764                       1452                            1845   \n",
       "990   31765                         82                             124   \n",
       "991   31766                         64                             118   \n",
       "992   31767                         63                             140   \n",
       "993   31760                        840                            1171   \n",
       "994   31761                          0                               3   \n",
       "995   31762                        508                             693   \n",
       "996   31763                          2                              15   \n",
       "997  550930                          0                               4   \n",
       "998  475003                          0                               0   \n",
       "999  550932                          0                               1   \n",
       "\n",
       "    vertex_label  \n",
       "0           Real  \n",
       "1           Real  \n",
       "2           Real  \n",
       "3           Real  \n",
       "4           Real  \n",
       "5           Real  \n",
       "6           Real  \n",
       "7           Real  \n",
       "8           Real  \n",
       "9           Real  \n",
       "10          Real  \n",
       "11          Real  \n",
       "12          Real  \n",
       "13          Real  \n",
       "14          Real  \n",
       "15          Real  \n",
       "16          Real  \n",
       "17          Real  \n",
       "18          Real  \n",
       "19          Real  \n",
       "20          Real  \n",
       "21          Real  \n",
       "22          Real  \n",
       "23          Real  \n",
       "24          Real  \n",
       "25          Real  \n",
       "26          Real  \n",
       "27          Real  \n",
       "28          Real  \n",
       "29          Real  \n",
       "..           ...  \n",
       "970         Real  \n",
       "971         Real  \n",
       "972         Real  \n",
       "973         Real  \n",
       "974         Real  \n",
       "975         Real  \n",
       "976         Real  \n",
       "977         Real  \n",
       "978         Real  \n",
       "979         Real  \n",
       "980         Real  \n",
       "981         Real  \n",
       "982         Real  \n",
       "983         Real  \n",
       "984         Real  \n",
       "985         Real  \n",
       "986         Real  \n",
       "987         Real  \n",
       "988         Real  \n",
       "989         Real  \n",
       "990         Real  \n",
       "991         Real  \n",
       "992         Real  \n",
       "993         Real  \n",
       "994         Real  \n",
       "995         Real  \n",
       "996         Real  \n",
       "997         Real  \n",
       "998         Real  \n",
       "999         Real  \n",
       "\n",
       "[1000 rows x 16 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vertices_df = pd.DataFrame(vertices_fetures)\n",
    "vertices_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
